RE: where to get SQL Server 7
Before looking for SQL Server 7.0, see if this helps:http://support.microsoft.com/default.aspx?scid=kb;EN-US;261334http://support.microsoft.com/default.aspx?scid=kb;en-us;818550
2005-02-14
PASS
RE: All About Transactions - Part 2
Well, well, well. A nicely written article that makes tons of sense. Recently I have had to write some complex T-SQL conversion scripts with multiple batches and a lot of logic. Getting the bugs worked out of them once written was tough to do and would have been a lot tougher without proper error handling […]
2004-12-03
1 reads
RE: db ownership
I am confused. Let me clearify what you are trying to tell us. OK, you made a copy of production database and put it on test servers.1. You remove users login from Sysadmin rights (good) and make them db_owners of the database that you just copy.I think it is alright to give your developer database […]
2004-05-19
RE: Cursor declaration.....
Add "For Read Only" at the end of the cursor declaration...DECLARE @c cursorSET @c = cursor FORSELECT * FROM FooFOR READ ONLY
2004-05-18
RE: SQL RS Windows NT Integrated Security
Yes you are right. But the hard coded value is stored on the report server. Users do not see that bit. Also in this case ( I could be wrong) U might need to turn on Impersonation. Let me know if U get it working. cheersanupam
2004-03-25
RE: Disaster Recovery
If you have a non-central site down and intend to perform disaster recovery and are doing snapshot replication, maybe the following will work.Set us a subscriber pull option to the publication, only to be ran when the subscriber site requests (in this case when disaster occurs).The publication should still be available from the distributor and […]
2004-03-15
RE: SQL 6,5 restore problem
Joel,Angela's suggestion is worth a go. It should work if your 6.5 data and log files were separate, and if there's been no increasing of either file (this is done manually in 6.5) since the original creation. Even if there has been increases - addition of new segments - then it may still work, but […]
2004-02-27
RE: How Can I Get a List of the Fields in a Table?
In Query Analyser type Exec SP_Help tablename . You may have problems if your owner is not DBO, as SP_Help does not let you prefix the table name with an owner. If this is the case you need to log on as the owner I believe to overcome this.
2004-01-28
1 reads
RE: Which SQL Server License to buy ?
Thank you very much for your response! Has helped us to understand the SQL Server licensing.Imran.
2004-01-28
RE: DTS Permissions
Yes. The user only has rights (dbo) to one database. There are no other rights assigned within the SQL Server. Also, how granular are the rights to DTS? Can I grant execute or modify without granting create? Daniel Mosmeyer
2003-12-11
1 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers