I am currently experiencing some problems using the database role of dbo_ddladmin in SQL2K. I am adding an NT user group/ad group to the ddladmin role and the users are telling not only can they not add new objects they can't even do a simple select statement. I am not too familiar with SQL2K but […]
2005-01-21
2 reads
CurtisThere are several versions of Reporting Services - Standard, Enterprise, Developer - you need to install the version that matches your version of SQL Server. If you're running XP then you need the Developer version.
2005-01-21
1 reads
According to this page, http://users.spark.net.gr/~yiapap/bldiagra.htm, seems that it is caused by ADO 2.8. I haven't tried it yet.
2005-01-21
Hello. Kriss,If i correct understood Your problem (You need to remove the owner of the table), You need to change the object owner with sp_changeobjectowner
2005-01-21
1 reads
INSERT INTO tbl2 (fname) SELECT fname FROM tbl1 WHERE ref#='123'Btw, the # sign isn't really good to be used as a column name. I have seen several threads here, where this caused more or less severe problems.
2004-12-16
In 7 years, this never deadlocked and it always retrieves a unique next number. This is just an exerpt of a function, but it finds a unique @iBatch (integer batch sequence #) in a table called batch. The key technique is to get the next iBatch: SELECT @iBatch = 1 + COALESCE((SELECT MAX(iBatch) FROM […]
2004-12-08
Farrel,No worries mate. Don't forget though: If you declare the variable within an sql string and exec it, it will generate a new spid and the variable will only have the lifespan of the new spid. It won't be useable anywhere else in your sproc - thats when you get the variable declaration error messages. […]
2004-11-10
Sorry, I didn't go back and look at the post, I had put servername and instancename in between greaterthan and lessthan signs, making it look HTML code... try: Servername\Instancename (local) will try and connect on the local system against a default instance (no instance name). If you have a named instance, you need to specify […]
2004-08-26
Yep, its possible to write an application which runs on the cluster and writes cluster events to a port. Check out the following page on MSDN: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/mscs/mscs/notification_port_example.asp
2004-08-13
Another question seems to have the incorrect answer checked as the correct answer.The correct answer of those listed is:"SQL Statement A will return its recordset sorted by myiT.Unique_ID descending , SQL Statement B:- will return it recordset sorted by the Alias 'Unique_ID' descending."I created 2 tables and tried the code out. I changed the values […]
2004-07-27
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers