Viewing 15 posts - 226 through 240 (of 283 total)
Not sure what you mean by command prompt. If you mean the equivalent of Query Analyzer you go to SQL Server Management Studio, connect to a database server and...
October 18, 2008 at 12:12 am
The Service Pack 1 is referring to the Windows service pack level rather than the SQL Server service pack level. There isn't a service pack 3 for SQL Server...
October 18, 2008 at 12:07 am
can you provide some more information about what you are trying to do?
October 17, 2008 at 2:20 am
In a cluster you are clustering the instance. So A,B,C will be in an instance on node 1 and D, E would be in an instance on node 2....
October 16, 2008 at 7:00 am
Where are you seeing the virus? Is it when they access the website or when they download something that is stored in the database? Can you extract the...
October 15, 2008 at 6:41 am
Have a look at the Certification forum (under Career) - there are lots of posts around this subject
October 13, 2008 at 5:20 am
Is the H: drive a resource in the cluster? It needs to be added to the sql group and it should be a dependency for the sql server resource.
October 12, 2008 at 1:33 am
Have a look in books online at the dbcc command, you can shrink a file or database using it. If the log file is too large do a transaction...
October 10, 2008 at 10:38 am
1) This can be done via a trigger so when the data is saved it is converted to upper case. But - this should be done in the...
October 10, 2008 at 10:34 am
Not sure what you mean. If you mean the database files are getting too big you can try shrinking the database. If the log file is very large...
October 10, 2008 at 10:27 am
Basically shrinkfile will reorganise the contents of the file and any unused pages will be moved to the end of the file. The unused pages at the end of...
October 8, 2008 at 5:37 am
We support both development and production systems/users. In our company we sit in the production (infrastructure) area but have moved between various areas over the years. I think...
October 8, 2008 at 2:05 am
Not sure what you are asking. The following has some information on log shipping in 2000:
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part4/c1361.mspx?mfr=true
October 7, 2008 at 5:41 am
We have many developers and they use Standard Edition SQL Server on our development servers. Development Edition would require them to have their own installation of SQL Server and...
October 7, 2008 at 3:36 am
I don't see a problem with this as long as the share has the correct permissions and is not on any of the SQL Server areas. I'd put it...
October 7, 2008 at 2:33 am
Viewing 15 posts - 226 through 240 (of 283 total)