Viewing 15 posts - 181 through 195 (of 280 total)
A valid point, however this particular prod server is not an OLTP and doesn't have high tx throughput, although available memory and CPU are low. My main concern by using...
May 21, 2012 at 5:37 am
A valid point, however this particular prod server is not an OLTP and doesn't have high tx throughput, although available memory and CPU are low. My main concern by using...
May 21, 2012 at 5:37 am
Thanks Dave, I'm running Profiler from a different, non-prod box and connecting remotely to the target, so little resources being consumed on the prod. I'm using Profiler for ease,...
May 21, 2012 at 4:53 am
Yes, execute:
xp_cmdshell 'eventvwr.msc', no_output in a new query window.
If this fails prefix with c:\windows\system32.
May 21, 2012 at 4:40 am
Looks like the error about Firewall being an invalid object is because the script is connecting to SQL Server as a user with the wrong default database.
You need to either:
1)...
May 18, 2012 at 9:11 am
How was the SQL Server instance configured at build time? If it's using a dedicated account i.e. YOURDOMAIN\MSSQLSERVER rather than NT SERVICE\MSSQLSERVER then ensure the account is a member...
May 18, 2012 at 8:08 am
Thanks Mike, just what I was looking for. If anyone else has suggestions too they would be greatly appreciated.
May 18, 2012 at 7:47 am
Can you post the command(s) you are sending to accomplish this, please? First thoughts are that you are specifying the existing .ndf and if the DB is attached to...
May 18, 2012 at 6:58 am
Agree with other posters here but more specifically on the VS problem, it's likely because SP1 is a requirement. I've seen this from time to time, upgrading your VS...
May 18, 2012 at 6:52 am
Right, something like...
bcp myTable format myFormatFile.fmt -Sservername -T -ddbname -t, -E -k
Should create your format file, do bcp /? to take a look at all the options.
To import, something like:
bcp...
May 18, 2012 at 6:43 am
My preference would be to use bcp. Create a format file first then use the format file and put multiple bcp calls into a batch file, one for each...
May 18, 2012 at 6:24 am
I'm OK with VBScript and I know what your script is trying to do. What's the error you're receiving, please?
May 17, 2012 at 9:24 am
Maybe I'm missing something but surely you just run it as a batch or SP?
I.e.
CREATE PROCEDURE myProcedure AS
BEGIN
insert into table1 (column1, column2,column3)
select column1,column2,'0' as Column3 from...
May 17, 2012 at 9:18 am
Very good summary article with some condensed information that's useful to know - thanks! Although I'm familiar with RAID and the effect on SQL Server I didn't know that...
May 1, 2012 at 3:57 am
Viewing 15 posts - 181 through 195 (of 280 total)