Viewing 15 posts - 1,036 through 1,050 (of 1,335 total)
Format the column in excel to be a text column and then upload the same to sql server with your column datatype as varchar/nvarchar.
June 21, 2007 at 5:59 am
This is a HOP problem. might be one of your servers are running under local system account or server are running under local computer account than domain users account. Change...
June 21, 2007 at 5:55 am
There is a key under the folder MSSQLServer in HKLM SOFTWARE check the service pack details there. By the way the file name is setup.log that will be created while...
June 21, 2007 at 4:20 am
http://vijaymodi.wordpress.com/2007/04/04/stored-procedures-vs-functions/ this link might give you some info that you have asked.
June 21, 2007 at 4:10 am
Sending mails may not be configured or might b configured wrongly chekc the link below for configuring mail for report server.
http://technet.microsoft.com/en-us/library/ms345234(SQL.90).aspx
June 21, 2007 at 3:33 am
I hope you have a merge command in sql 2005 like what you have in oracle databases.
June 21, 2007 at 2:46 am
Sure the company would have hundred thousand dollars if they use MySQL as its a opensource database. But i don't think so that MySQL has all the features and support...
June 21, 2007 at 2:25 am
One small correction, send mails through sql server dbmailing system. And you need not have to have a client installed for using database mail in sql 2005.
June 21, 2007 at 2:09 am
Check if the other users have permissions to procedure used to send mails. The reason that sa is being called might be they don;t have enough permission to send mails.
June 21, 2007 at 2:08 am
Is your authentication mechanism changed from Mixed Mode to Windows mode check that. You will not be able to login with sql ids if your server is running under windows...
June 21, 2007 at 2:04 am
I you have taken a registry key backup you can restore them. Else clear files that have been created by sp4 installation this can be found on the setlog file...
June 21, 2007 at 1:51 am
The better option is to move using DTS to move the data. And regarding the collation you can set the collation to French base in your sql server and move...
June 21, 2007 at 1:46 am
Placing different filegroups under different drives will enhance performance. But under the same drive you will not get muchas expected.
June 21, 2007 at 12:50 am
Did you check what is the size it using if your data file is fully occupied then shrinking will not give you space.
June 20, 2007 at 11:02 pm
script the jobs, logins and user permissions and apply them to the new 2005 server.
June 20, 2007 at 10:56 pm
Viewing 15 posts - 1,036 through 1,050 (of 1,335 total)