Viewing 15 posts - 901 through 915 (of 1,478 total)
If the future pleas post questions regarding to SQL Server 2000 in a SQL Server 2000 forum and not in a SQL Server 2005 forum.
You can do it...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 15, 2009 at 4:11 am
Suresh B. (7/15/2009)
alter database tempdb modify file (name = templog, filename = 'D:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\templog.LDF')
And you have...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 15, 2009 at 4:04 am
Check out the fallowing URL – http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/8ceb82fd-fc56-4a99-9317-590cca683f2b. I don’t have time to test it, but it seemed to help some of the DBAs that are participating in the...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 15, 2009 at 3:14 am
You should change the parameter type to datetime or smalldatetime instead of char(8). When you use a character as a parameter and then add 1 to it, the...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 15, 2009 at 2:27 am
Are you sure that the you got the correct SQL Statement that causes this error? Could it be that another statement is causing the error?
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 15, 2009 at 1:05 am
Creation of index is part of the backup and also part of the restore, so you don’t have to recreate indexes when you restore a database.
When you run sp_spaceused...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 14, 2009 at 10:57 pm
If you are doing it from a job, then you don’t need to use xp_cmdshell. When you create the job’s step you can select the step’s type. ...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 14, 2009 at 6:02 am
There could be few reasons for this. Do you know if the server is still online? Could it be that the server’s service was stopped? Another...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 14, 2009 at 2:38 am
You can use pattern search with like. Here is an example that shows you how to search only for strings that have only numeric digits. You can...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 13, 2009 at 1:26 pm
Identity doesn’t prevent you from truncating a table. There are other things that can prevent table from being truncated (for example – permissions problem, table is referenced by another...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 30, 2009 at 12:52 am
Pleas provide us the view definition as well, the insert statement that doesn’t work and the error message that you get. Without this information, we can only guess what...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 30, 2009 at 12:46 am
Why do you think that filestream needs a 64 bit edition and won’t work with 32 bit edition? Take a look at this URL http://msdn.microsoft.com/en-us/library/cc645993.aspx (Features supported by...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 29, 2009 at 10:32 pm
fn_trace_getinfo(default) is a function that returns information about server side trace. Since SQL Server has a default trace, you got back information about the default trace. This however...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 29, 2009 at 12:59 pm
2 Tim 3:16 (6/29/2009)
SELECT * FROM :: fn_trace_getinfo(default)displays ALL traces running
sp_trace_setstatus @traceid=1, @status=20=stop,1=start,2=stop/purge
ie.
exec sp_trace_setstatus 1, 1
I think that you are referring to server side trace. The original poster referred...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 29, 2009 at 10:33 am
Try running DBCC TRACESTATUS to check which trace flag is set on. After that you can turn it off DBCC traceoff command
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 29, 2009 at 12:30 am
Viewing 15 posts - 901 through 915 (of 1,478 total)