Viewing 15 posts - 976 through 990 (of 1,335 total)
Are yout trying to do it from GUI or the command line. If from GUI why do you specify the parameters. Then check if the server has anyother instances installed...
June 26, 2007 at 1:36 am
Jim,
Even with 3GB of RAM you will not be able to use /3GB switch as it requires a minimum of 4GB RAM to take effect. You can check the available...
June 26, 2007 at 1:17 am
Check the post given below your questions all are answered.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=368205
June 26, 2007 at 12:53 am
See if you can make a client connection to the server mentioned in the package. If not create an alais and run the package that should work fine.
June 25, 2007 at 11:53 pm
I too find no way than using multiple text/excel files. You say your data is about 5GB but excel can handle only 64K rows per sheet and there is a...
June 25, 2007 at 11:50 pm
Check what is the space being used by the data and log file. Also do the shrinking by file rather than doing it at database level. If you say that...
June 25, 2007 at 11:43 pm
Check if the given script below helps you.
osql -L >> c:\serverlist.txt
FOR /F %%I in (C:\ServerList.txt) do isql -S %%I -E -w500 -r1 -n -i database_SCRIPT.txt >> C:\database_RESULTS.log
Database_script should have the...
June 25, 2007 at 11:09 pm
Try this query given below.
use
master
go
select
* from sys.server_principals
June 25, 2007 at 10:58 pm
You can use the procedure in the link given below to do the same.
http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=271
June 25, 2007 at 10:55 pm
Check the link please.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/508c686d-2bd4-41ba-8602-48ebca266659.htm
June 25, 2007 at 10:53 pm
Why do you use a hash table while moving data to other database. is it joining data between 2 or more tables and inserting into the destination database. If so...
June 25, 2007 at 10:48 pm
Your server has only 2GB of RAM. And adding the .3GB switch is of no use as it is to be used only when the server has more than 4Gb...
June 25, 2007 at 10:43 pm
Is remote connections enabled in your sql server if not do that and check if you are able to connect to the database engine remotely.
June 25, 2007 at 8:25 am
You can add the developer to db_dlladmin role in that database alone so that he will be able to fire all DDL sttements in that database but not in other...
June 25, 2007 at 8:24 am
Thanks Sugesh,
So, to clarify, you are saying that the System procedures are in their own schema, therefore the time-penalty of "sp" prefixes has been eliminated in 2005?
No....
June 25, 2007 at 8:19 am
Viewing 15 posts - 976 through 990 (of 1,335 total)