Viewing 15 posts - 7,231 through 7,245 (of 13,460 total)
the few times i've read about this kind of issue, it was situations that i'm not sure apply here:
connection pooling: create a temp table, and then issue another statemetn...sometimes your...
July 1, 2011 at 6:45 am
Syed Jahanzaib Bin hassan (7/1/2011)
July 1, 2011 at 6:20 am
you cannot encrypt a "table definition" (CREATE TABLE.....).. the column types and table name are stored in sys.tables and sys.comluns., and all the related obejects like constraints and indexes are...
July 1, 2011 at 6:14 am
part of what you posted says Year(today) -1
that would be 2010, correct? isn't that what you want?
June 30, 2011 at 2:54 pm
as far as not breaking anything, if you were going to do an UPDATE, or add a job or reindex that wasn't one of the famous scripts here on SSC,...
June 30, 2011 at 12:16 pm
first i'd suggest practicing on a completely unfamiliar system; you get tunnel vision looking at your own laptop and machines, and make assumptions aobut what is in place and what...
June 30, 2011 at 12:06 pm
are you using a SQLCcmdObject with parameters to call the proc, or as a text command with ExecuteNonQuery??
show me the code you are using to call the proc, i'd...
June 30, 2011 at 11:10 am
i'll bet at least one row is an empty string;
an empty string can be converted to Integer, but not Numeric:
SELECT CONVERT(int,'')--works! value = 0
SELECT CONVERT(NUMERIC(8,0),'') --fails! Error converting data type...
June 30, 2011 at 10:59 am
ok since we are showing off all our cursor abilities, here's my contribution to the same issue:
mine is designed to search the db, and provide you with follow up SQL's...
June 30, 2011 at 10:31 am
it depends completely on how you are exporting the data; you never mentioned what you are using.
Are you using SSIS? bcp? your own application?
bcp requires a format file to describe...
June 30, 2011 at 10:21 am
third party tools exist that are specifically designed for this.
What's UP! and SQLPing are two that come to mind,and both are either free or have free versions.
otherwise, if you are...
June 30, 2011 at 9:07 am
no, if you have already installed the ODBC driver on your server, you don't need any SDK or anything else.
all you need to do is use the screenshots int hat...
June 30, 2011 at 9:03 am
the errors pretty clear.
you are trying to create a unique primary key on an existing data. but at least one combination of those two columns are not unique. the values...
June 30, 2011 at 8:39 am
the IBM website has a walk through on using the SSMS GUI to create a linked server;
does this help?
June 30, 2011 at 8:03 am
you can create a database that researves a ton of freespace for future growth; when you restore that backup, it requires all that reserved free space as well...so getting a...
June 30, 2011 at 7:21 am
Viewing 15 posts - 7,231 through 7,245 (of 13,460 total)