|
You need the SQL Server 2005 Backward Compatibility Components package. You can find this at the latest 'Feature Pack' download. The last update was in February 2007 which can be found here[^].
SMO - Server Management Objects - is a set of .NET components that perform much the same function as DMO.
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
|
The sp_who2 internal procedure provides the following information:
Spid—The system process ID.
status—The status of the process (e.g., RUNNABLE, SLEEPING).
loginame—Login name of the user.
hostname—Machine name of the user.
blk—If the process is getting blocked, this value is the SPID of the blocking process.
dbname—Name of database the process is using.
Cmd—The command currently being executed (e.g., SELECT, INSERT)
CPUTime—Total CPU time the process has taken.
DiskIO—Total amount of disk reads for the process.
LastBatch—Last time a client called a procedure or executed a query.
ProgramName—Application that has initiated the connection (e.g., Visual Basic, MS SQL Query Analyzer)
You can use them.
Arun Singh
Noida.
|
|
|
|
|
thank for your reply.Thank a lot
|
|
|
|
|
Hi,
I have to create a SQL CE database file (*.sdf) on my PC. I intended to call several web services to get data and create a 'localDB.sdf' with a program running on my PC. I have created windows application project but I could not add reference to the System.Data.SqlServerCE assembly.
The System.Data.SqlServerCe didn't appear in the .net references tab. I had browsed and added the assembly manually but it didn't work because my framework is 2.0 and the assembly looks for CF 2.0.
How can I use the SqlCeEngine class in a Windows application? Or can I create a *.sdf file using a different class?
thanks,
- ferudun
|
|
|
|
|
Don't cross post.
You've asked this same question in 4 different forums, all within a 10 minute time span.
The people here answer questions on a volunteer basis and may not respond in a timeframe you desire or find acceptable.
I've responded to your initial message here[^].
|
|
|
|
|
You need the desktop version of the runtime. The best place to start is probably the "Compact Edition Developer SDK"[^].
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
Hi,
How can I prevent users of a computer from viewing records and fields of my DB in Enterprise Manager (or SQL Server Management Studio) installed on the computer?
Like access files that can set password for them, is there any way to protect DB in SQL Server ?
Best wishes
|
|
|
|
|
You have to play around with user privileges for the table and columns.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
|
hspc wrote: In addition, SQL Server 2005 encryption can be used
Yep. I'll have to look at those links later.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
You can try, but ultimately if they have administrative privileges on the computer they can undo anything that you do.
DoEvents: Generating unexpected recursion since 1991
|
|
|
|
|
hi
My aim is to get list of tables in a database (access) if any one has any idea please let me know
thank u
regards
sindhu tiwari
its me sid
|
|
|
|
|
|
Wish I could have had that link a couple months ago. I wound up doing the same general query after digging around inside Access :->
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
you can see list of table in sysobjects table of your database.. this is where the names of table is reside...
|
|
|
|
|
Hi all ,
What is your solution for Reading/Writing persian date from/into Sql Server 2005 and do calculations on persian dates?
Thanks in advance.
-- modified at 2:55 Monday 29th October, 2007
|
|
|
|
|
Hello
I need to view the data in the datagridview from the table through an sql statment but i don't want the date will be like: "1983-01-01 00:00:00" i want just show:"1983-01-01" or show:"01-01-1983"
Thanks in advance
Assaf
|
|
|
|
|
You can done it by convert(varchar,getdate(),101)
umesh
|
|
|
|
|
there are two ways to achieve it either from sql server by using Convert(varchar(30),getdate(),101) it will convert your date to desired format.
other one is use Format(XXX, "dd MMMM, yyyy") function in .NET ...
Arun Singh
Noida.
|
|
|
|
|
Set:
DataGridView.Columns(n).DefaultCellStyle.Format = "dd/MM/yyyy"
The Fanatical All Black Supporter - Kea Kaha
|
|
|
|
|
I am creating a report using Reporting Services in SQL Server 2005 that contains a table. Table only has two columns both containing 20 or less characters. I would like my table to wrap into a 2nd or 3rd column before going onto the next page.
Thanks
|
|
|
|
|
I don't believe that this is possible. You can't add columns dynamically to a Table object at runtime. You can only represent the data in the structure returned by your SQL query and programmatically work with the data and apply visual formatting through the expression-based programming model.
Paul Marfleet
|
|
|
|
|
Thank you for your reply, however I do not want to add columns to my table I just want my table to wrap before running onto the next page.
|
|
|
|
|
SELECT Work_Requests_1.id, Work_Requests_1.work_req_name, Work_Requests_1.description, Work_Requests_1.req_name,
Work_Requests_1.cost_center,
CASE [type] WHEN 'Inst' THEN 'Installation' WHEN 'Dein' THEN 'Deinstall' WHEN 'Powe' THEN 'Power' WHEN 'Rout' THEN 'Routing' WHEN 'Fire' THEN
'Firewall' WHEN 'IPRq' THEN 'IP Request' WHEN 'DHCP' THEN 'DNS/DHCP' WHEN 'Hire' THEN 'New Hire' WHEN 'Tick' THEN 'Trouble Ticket' WHEN 'Asst'
THEN 'Asset Management' WHEN 'Spec' THEN 'Spectrum Allocation' WHEN 'Othr' THEN 'Other' ELSE 'Not Specified' END AS type,
Work_Requests_1.type AS lookup_Type, Work_Requests_1.location, CONVERT(VARCHAR, CONVERT(DATETIME, Work_Requests_1.compdate, 107),
107) AS compdate, Work_Requests_1.phone, Work_Requests_1.email, CONVERT(VARCHAR, CONVERT(DATETIME, Work_Requests_1.sendate, 107),
107) AS sendate, CONVERT(VARCHAR, CONVERT(DATETIME, Work_Requests_1.wishdate, 107), 107) AS wishdate,
CASE status WHEN 'INP' THEN 'In Progress' WHEN 'COM' THEN 'Completed' WHEN 'HOL' THEN 'On Hold' WHEN 'CAN' THEN 'Cancelled' END AS status,
Work_Requests_1.status AS lookup_Status, REPLACE
((SELECT dbo.Work_Requests_Staff.name
FROM dbo.Work_Requests_Staff INNER JOIN
dbo.Work_Requests ON dbo.Work_Requests_Staff.alias = dbo.Work_Requests.lead
WHERE (dbo.Work_Requests.id = dbo.Work_Requests.id)), 'na', 'NOT Assigned') AS lead, Work_Requests_Staff_1.alias, REPLACE
((SELECT Work_Requests_Staff_1.name
FROM dbo.Work_Requests_Staff AS Work_Requests_Staff_1 INNER JOIN
dbo.Work_Requests AS Work_Requests_1 ON Work_Requests_Staff_1.alias = Work_Requests_1.contact
WHERE (Work_Requests_1.id = Work_Requests_1.id)), 'na', 'NOT Assigned') AS contact
FROM dbo.Work_Requests AS Work_Requests_1 INNER JOIN
dbo.Work_Requests_Staff AS Work_Requests_Staff_1 ON Work_Requests_1.lead = Work_Requests_Staff_1.alias
When I execute the above query it is returning an error:Subquery returned more than 1 value. This is not permitted when the subquery follows =,!=,<,<=,>,>= or when the subquery used as an expression.
Rajee
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
