My guess is that you have some problem with your disk. Since the log backup is smaller then the full backup, when you are running the log backup, the...

For some reason you don’t want to explain what you need. From what I understood, you already have an SQL Server installed on your machine and you want to...

lamin.mha (11/3/2009)

---

Adi Cohn-120898 (11/3/2009)

---

It looks that you have few places with an apostrophe in the string (for example one of your parameters in the first error that you get...

You’ll have to explain your question. Do you want to install a second instance on a server? Do you want to rename an SQL Server instance? Or...

It looks that you have few places with an apostrophe in the string (for example one of your parameters in the first error that you get is ...

The option to enable or disable xp_cmdshell with sp_configure was intreduced only SQL Server 2005. With SQL Server 2000 this extended stored procedure is always enabled.

Adi

Do you get any errors? Are you sure that you are connecting to the correct server? Did you try to see with profiler or another tool that the...

At first I thought that you are talking about the tables’ and index’s statistics that are part of the database and therefore are being restored with the database. Now...

You shouldn’t rely in your code on the configuration or setting of the server/session. You should make sure that your code will run regardless of the language and date...

What type of restore are you using? Are you restoring parts of the database only? Also how did you determined that the statistics are not being restored?

Adi

I don’t really know what military format is. You asked for a specific format in the first message and I wrote a code that shows the date using the...

Here is another way of doing so:

select convert(char(5),getdate(),9)

select convert(varchar(10),getdate(),101) + ' ' + convert(char(5),getdate(),8) +

CASE WHEN DATEPART(hh,getdate())>= 12 then ' PM' ELSE ' AM' END

Notice that althgou...

You’ll have to use the date and time as a part...

The easiest way is to use the maintenance wizard. It will create a different file for each backup and will delete old files according to the way that you...

I think that you can do it by running bulk insert command or using insert select statement with openrowset function and the bulk driver (you can read about both...