Viewing 15 posts - 61 through 75 (of 351 total)
Minnu (5/17/2013)
Am trying to call a batch in sql server stored proc.
CREATE PROCEDURE test_batch
AS
BEGIN
tdeclare @bat varchar(200)
set @bat = 'd:\test\test.bat'
...
May 17, 2013 at 1:38 am
eamasalunga (5/17/2013)
Hi,Yes I've tried disabling and re enabling the queue, restored the database, restarted the sql service and even restarted the server itself but still getting the said error.
Please check...
May 17, 2013 at 1:22 am
Have you tried Stopping and starting the queue..?
May 17, 2013 at 12:45 am
rsorrentino (5/2/2013)
May 2, 2013 at 3:14 pm
Sqlism (5/1/2013)
One more similar Question.I can connect to SQL Server by RDP to that server but not with my management studio. what i am missing here ?
Thanks!
Check TCP/IP is enabled.
May 1, 2013 at 5:47 pm
There are multiple ways to get the currently running queries,
One way is through this script[/url].
The script is same as you running the activity monitor.
May 1, 2013 at 10:45 am
Usually statistics will be created when you created an index or when a select statement where condition column doesn't have index will also create statistics.
Statistics will occupy some disk space...
May 1, 2013 at 1:50 am
Take 2 excel sources and select only 1 attribute in each as you requeried then use a lookup tranformation and excel destination. i hope understand
April 17, 2013 at 4:43 pm
Why did you restore a dB ?
Instead you would have been taken a log backup that should cleaned the log file.
Is it a production database ?
February 25, 2013 at 7:48 pm
Guras (2/6/2013)
We are migrating to a new domain and I have few questions -1. I need to change the SQL server start up service account from domain1\SVC_SQL to domain2\SVC_SQL
No...
February 6, 2013 at 1:00 pm
Does S1 and S2 has same configuration of RAM, CPU, traffic and NETWORK Speed ? all of these makes a diffrence too
February 6, 2013 at 12:20 pm
adonetok (2/6/2013)
They have the same size and data structure. (More than 5000 records, has the same columns'...
February 6, 2013 at 12:15 pm
You could shrink database to release the unused space anyways..and set to auto growth on data file.
Even though your database is in simple mode, the log file will grow bigger...
February 1, 2013 at 12:37 pm
I haven't queried that and I would try querying that in an hour or so.
Could you please tell me what about it?
January 29, 2013 at 5:18 pm
Can you run CheckDB on the 2005 database? Or do you not have a pre-upgrade copy?
--Cannot run dbcc checkdb, also no pre-upgrade backups
Did the DB switch into emergency mode without...
January 29, 2013 at 4:18 pm
Viewing 15 posts - 61 through 75 (of 351 total)