Viewing 15 posts - 43,876 through 43,890 (of 49,571 total)
Backup log with truncate only will discard inactive transaction log entries from the tran log. This frees up space within the log file that can then be released to the...
October 12, 2008 at 12:30 pm
Ok...
Are you trying to return a resultset (from the select statement) or just a output variable?
The error is correct. In terms of the SET statement, the column CalculatedStatus does not...
October 12, 2008 at 12:24 pm
Duplicate post.
Replies to the following thread please:
http://www.sqlservercentral.com/Forums/Topic584586-1292-1.aspx
October 12, 2008 at 12:19 pm
"Data Source=(local)" resolves to the default instance on the local machine. Express always installs as a named instance with the instance name "SQLEXPRESS"
Try "Data Source = < Server name...
October 12, 2008 at 12:15 pm
Other than conversions I haven't found a good reason to convert a datetime to a float or int.
I'm sure you could figure out what I meant.
October 12, 2008 at 9:21 am
There's no such thing in SQL as 'Order of rows' unless you specify an order by. The order that the cursor returns them may change from one run to another.
How...
October 12, 2008 at 9:05 am
Peso (10/12/2008)
In my experience, the table variable flushes to disk when approx two pages has been filled.
Interesting. How are you monitoring that?
October 12, 2008 at 9:03 am
Adi Cohn (10/12/2008)
I didn’t try to move a database from SQL Server 2008 to SQL Server 2005, but I’d be very surprised if it will work.
It won't, regardless...
October 12, 2008 at 5:59 am
What statement were you trying to run? Was that the full error message? Was there any reference to what resource it was trying to lock?
October 12, 2008 at 3:19 am
SQL injection is a front end vulnerability that comes from concatenating together SQL statements and executing them.
The way to completely prevent SQL injection is simple, but may take a...
October 12, 2008 at 3:18 am
Audit tables I probably would put a pk onto. Probably just an int identity, but I would want something there to uniquely identify a row. Especially if auditors want reports...
October 12, 2008 at 3:11 am
And, heh... guess I'm still angry at the fact that the DateTime2, Date, and Time won't convert.
Why? Other than conversions I haven't found a good reason to convert a date...
October 12, 2008 at 2:44 am
Dugi (10/12/2008)
October 12, 2008 at 2:41 am
rajganesh.dba (10/11/2008)
3.SQL server maximum memory setting changed to more value(like 5Gb) with /3GB and /PAE.
How much memory on that server? Ususally if you've gopt 4 GB then you would want...
October 12, 2008 at 2:34 am
saby (10/11/2008)
gail then wat shud i do... i thing i cannot run this sp on subcription database
Which proc can't you run and why not?
sp_repldone and the others I gave you...
October 12, 2008 at 2:29 am
Viewing 15 posts - 43,876 through 43,890 (of 49,571 total)