That was the same link provided by me initially..

in the above article he mentioned about a trace flag like –c –m T3608.

Here we need to just...

Krasavita (11/24/2009)

---

I need my sql server to run asap. Now I just want to be the way it was before for now. I removed everything from e drive and want...

The service under which SQL Server is starting has permissions to that location right??

Just to confirm, what about MssqlsSytemresource DB it's in the same directory as Master DB?

Where did you move the Model Database to?

What is the previous and current location of Model DB. It seems SQL Server is trying to find it at the location "E:\MSSQL\MSSQL.4\MSSQL\Data"

There seems to be no change in Code1 and Code2 except hardcoded values..

Are you making sure the Date value entered by the user (date input) is a valid date format.

Is...

Now you know which companies use SQL Server, be proud.

What Slick was referring is to use Import/Export Wizard...

That is the easiest and quickest method to export excel files to SQL Server table.

If the task is to be performed...

Go to the Error Log located in MSSQL.X\MSSQL\LOG

look for the file named ErrorLog (without any extension)

See what's mentioned there and post it here if possible..

So you never knew Stored Procs existed 😉

Thanks for clarifying, but if there are multiple conditions and you run those files to solve that issues, running all of them at the same time will it not cause...

Pardon my ignorance, can I know why you need to run multiple .sql files from script?

shanila_minnu (11/24/2009)

---

i am trying to setup a transactional replication.I created one database in publisher with some data and the same database with same data in subscriber.In this case ,should i...

Since you were never able to connect to SQL Server from VS2008, let me know what are the steps you are performing to create a new connection?

In addition to what Lynn suggested, you can run the following T-SQL Command

select * from msdb.dbo.sysdtspackages90

Edited: You may want only the name of the deployed packages, so use this

select...

SSC has never been a Braindump site...