SET ROWCOUNT your_number_of_row. causes SQL Server to stop processing the query after the specified number of rows are returned. or Using TOP and PERCENT to limit the number of rows returned in the result set.
2003-07-10
MS says they resolved this in SP1? Are you still getting the error
2003-07-10
No they do not need to be running. Are they alwayy there? they shlould just "pop in and out"?
2003-07-10
1 reads
BTW- I just found this cool page of information on this site. http://qa.sqlservercentral.com/columnists/dPriyankara/versionservicepack.asp Specifically, it shows the use of SELECT SERVERPROPERY('productlevel') That will return the 'readable' version of your SQL Server product. I ran that command on my SQL Server and it returned: SP3 Plain and simple. -SQLBill -SQLBill
2003-07-07
You may have to generate a script larger than intended and then extract the bit you want. In EM, right click on DB name, All Tasks, Generate SQL Script, General tab leave asis, Formatting tab uncheck DROP, Options tab check Script database users and database roles. Then Preview from the General tab.
2003-07-05
Cheers. Just out of interest - why does it set this as default - is there a good reason? (I want to perform trans backups)
2003-06-27
2 reads
...further to that, the database had to be called "victimdb" but no longer works on SQL2k anyway. You can stop mssqlserver and then play around with a hex editor in the mdf file until you get the sort of corruption you're after? For instance, if you change the first byte it'll go straight into suspect […]
2003-06-10
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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