In your code you are working with 3 data types. The first data type is the parameter’s data type - char(8) . The second data type is the...

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...

Suresh B. (7/15/2009)

---

You should mention the full file name. Not just the folder name. For example:

alter database tempdb modify file (name = templog, filename = 'D:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\templog.LDF')

And you have...

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...

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...

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

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...

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. ...

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...

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...

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...

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...

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...

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...

I think that you are referring to server side trace. The original poster referred...