Viewing 15 posts - 5,401 through 5,415 (of 9,712 total)
What is your data source? MySQL? SQL Server? DB2? Oracle?
What is your data destination? MySQL? SQL Server? DB2? Oracle?
EDIT: Are you querying MS Access? What is "nia"? A linked server...
July 29, 2011 at 10:29 am
Have you set the Delay Validation property of your connection manager to True?
July 29, 2011 at 7:52 am
I don't remember, honestly. Have you googled network card names? Do you have a local network admin you can speak to?
You might get better results with that method.
July 29, 2011 at 7:50 am
dekuwisdom (7/29/2011)
this is what i tried executingSELECT *
FROM nia.nia_records r
INNER JOIN nia.nia_districts d
ON LEFT(r.CenterNo,CHARINDEX('-',r.CenterNo,0)-1) = d.district_Code;
and i got this error message
Error Code: 1305. FUNCTION CHARINDEX does not exist
Have you tried...
July 29, 2011 at 7:42 am
The best way to do it is script the tables, indexes, etc. over to your destination server. Then use the Export Import Wizard to append the data to the existing...
July 29, 2011 at 7:37 am
Did you name the table yourself? Can you fix it? Using special characters as the first "letter" of a table name is a really bad idea. In fact, SQL Server...
July 29, 2011 at 7:35 am
You can't do BI without knowing the basics of SQL Server administration and development. You don't have to know everything, but knowing the basics is essential.
I would start training with...
July 29, 2011 at 7:31 am
OP, can you please provide the link to the discussion you said you would start in the certification forums so others can respond there?
July 29, 2011 at 7:29 am
Koen Verbeeck (7/29/2011)
Ugh. Another copyright violation.http://www.sqlservercentral.com/Forums/Topic1150675-391-1.aspx?Update=1
Original article:
http://www.databasejournal.com/features/mssql/sql-server-index-t-sql-statements.html
Looks like someone already removed the topic. It takes me to the forums home now.
July 29, 2011 at 7:26 am
SAN experts (or experts with SAN Monitoring experience) needed at this thread with monitoring tool recommendations, please:
http://www.sqlservercentral.com/Forums/Topic1149982-391-1.aspx?Update=1
July 29, 2011 at 7:22 am
SkyBox (7/29/2011)
Can you recommend an inexpensive SAN monitoring tool?
I don't know a whole lot about SAN monitoring, but let me ping in a few other experts and see what they...
July 29, 2011 at 7:21 am
dekuwisdom (7/29/2011)
SQL Error 1305: FUNCTION nia.CHARINDEX does not exist
... but am still interested with yours.If you can tell me why am getting...
July 29, 2011 at 7:19 am
All,
Can you please stop replying to this thread and use the one posted in the Certification forums? That's the proper place for this discussion.
July 29, 2011 at 7:15 am
chandan_jha18 (7/29/2011)
Brandie Tarvin (7/29/2011)
chandan_jha18 (7/29/2011)
Can you please explain what you meant by saying that the website was using a domain account?
The website that hosts the reports also pulls data from...
July 29, 2011 at 7:12 am
chandan_jha18 (7/29/2011)
Can you please explain what you meant by saying that the website was using a domain account?
The website that hosts the reports also pulls data from various SQL Server...
July 29, 2011 at 6:15 am
Viewing 15 posts - 5,401 through 5,415 (of 9,712 total)