Viewing 15 posts - 9,091 through 9,105 (of 9,399 total)
I'm not familiar with this error myself, but perhaps this may be of help. http://www.sqlservercentral.com/Forums/Topic13772-7-1.aspx
August 6, 2013 at 6:37 am
I looked at the stored procedure, but it doesn't look like it hits anything that hard. It looks to me like an upgrade or version management procedure for ManageSoft,...
August 6, 2013 at 6:04 am
Erland Sommarskog (8/5/2013)
drlloyd2 (8/5/2013)
August 6, 2013 at 5:55 am
If the query hasn't changed and has suddenly started to throw errors, then something else must have changed. What else changed on the server that isn't working that hasn't...
August 5, 2013 at 12:05 pm
You could write a query to return a list of all tables that include the emp_id field name and build a SQL DELETE statement as a part of the query....
August 5, 2013 at 12:00 pm
OK. But, in this case, I know the users have no other permissions granted, only what they've got through role membership.
I'm not trying to be a complete pain here,...
August 5, 2013 at 8:19 am
If you're running a penetration test using the 'sa' user, then you may have missed one of the very first steps in securing a server - disable the 'sa' login....
August 5, 2013 at 8:04 am
Depending on your experience, the stairway on DML is a good place to start. http://www.sqlservercentral.com/stairway/75773/
Then, since so many people seem to struggle with design, here's a stairway for that. http://www.sqlservercentral.com/stairway/72400/
All...
August 5, 2013 at 7:10 am
If I'm reading your OP correctly, you're trying to emulate the Oracle TO_CHAR function, which SQL Server doesn't have. The real stumbling block you run into here is that...
August 5, 2013 at 6:31 am
TempDB will use whatever space it needs for the workload. If you have procedures that create temp tables, populate them, manipulate them, return them and the drop them, the...
August 2, 2013 at 6:57 am
The Texas A & M one sounds like the best one for me. Someone else here used a service once, but I don't know which one. It was...
July 31, 2013 at 2:17 pm
Lowell - Thank you! Having address validation is a very good tool to have. I can't tell you how many times we do it and the USPS charges...
July 31, 2013 at 2:02 pm
Joie Andrew (7/31/2013)
If you can ping the server by name, then DNS is resolving the name, but SQL Server might be configured to allow connections only on a specific...
July 31, 2013 at 6:07 am
OTF (7/18/2013)
Here comes a silly question...What product does SQL Sentry offer that does what the OP requires?
I use SQL Sentry myself and love it. It is a great product...
July 31, 2013 at 6:06 am
The way I do it is to track the total and free space for each volume. I capture the data into a table daily. That allows me to...
July 31, 2013 at 5:57 am
Viewing 15 posts - 9,091 through 9,105 (of 9,399 total)