Viewing 15 posts - 7,366 through 7,380 (of 7,636 total)
check for corruption?
March 24, 2008 at 1:02 pm
Could you enter the error text in a post? The title is getting cut-off halfway through for me.
March 24, 2008 at 12:40 pm
and make sure that you are in the Neuro database.
March 24, 2008 at 12:34 pm
I never saw databasename filled-in in SQL2000, use DBID instead. Error code is only filled in for error events.
March 24, 2008 at 12:32 pm
Marios: Glad I could help. I lost many days to this problem the first time that I tripped over it.
March 24, 2008 at 9:14 am
Ooops, my bad. Now I see that you are going DB to DB.
At some point you will have to generate your SQL command as a string replacing 'Client_DB' with...
March 24, 2008 at 9:01 am
If your stored procedure is stored IN Client_DB then you do not have to name it.
March 24, 2008 at 8:57 am
My recollection is that a timestamp is unique within a database to a transaction. Thus multiple rows within a table (and the database) can have the same timestamp, but...
March 24, 2008 at 8:48 am
Chirag (3/24/2008)
My procedures get changed daily and i cant generate the alter script as iam using SQL 2005 RTM ( i cant change it).
How does SQL 2005 RTM prevent...
March 24, 2008 at 8:29 am
Even better than Oracle equivalents, there are implemented standards:
Select *
From INFORMATION_SCHEMA.COLUMNS
Where column_name = '{colName}'
March 24, 2008 at 8:17 am
Glad it worked out.
March 23, 2008 at 8:49 pm
Aaron McConnell (8/3/2007)
we'd have to rename it to something like Structured Query and Relational Language -...
March 23, 2008 at 7:42 pm
ace (3/20/2008)
Based on your suggestions I ended up constructing a query that uses a Common Table Expression to create a temporary table of dates to join against
Why a temporary table?...
March 23, 2008 at 2:22 pm
Ghanta (3/23/2008)
EXECUTE master..xp_cmdshell 'bcp "SELECT * FROM inputs.dbo.mytable"
queryout "\\ABC\MS\myexport.txt" -c -t ""
-f "\\ABC\MS\Format\ff1.fmt" -T -S ABC
At first glance, this looks OK to me. What is the problem...
March 23, 2008 at 2:11 pm
I don't know SSIS that well, but it can certainly be done in plain old Transact SQL (i.e., the SQL Server Data Engine). I do it all the time.
March 23, 2008 at 2:05 pm
Viewing 15 posts - 7,366 through 7,380 (of 7,636 total)