Viewing 15 posts - 11,101 through 11,115 (of 14,953 total)
Not entirely clear on what you mean.
If you have one database that needs to exist on multiple servers, you can use replication or log shipping to keep them in synch....
February 5, 2009 at 2:57 pm
Brad's comment about a mission statement, even one worded as a code of ethics, or vice versa, would definitely be of use to people new to the profession. Would...
February 5, 2009 at 2:56 pm
Have you read the MSDN article on using that query? It's entirely possible it simply doesn't have the data in it that you are looking for.
February 5, 2009 at 2:40 pm
You could define a CLR that would check filesize for you. Or an ActiveX script that could be run as part of an SSIS package. CLR would be...
February 5, 2009 at 2:35 pm
David Portas (2/5/2009)
GSquared (2/5/2009)
February 5, 2009 at 2:31 pm
Can you run a select on the data you are trying to pull from the remote server? Just that part of the view by itself, I mean.
February 5, 2009 at 2:22 pm
frank.morales (2/5/2009)
February 5, 2009 at 2:21 pm
Open Management Studio, click on a database name. Then click on it again. Then hit the 1 key on your keyboard. It'll try to rename the database....
February 5, 2009 at 2:16 pm
I could be wrong, but it looks like your column definitions won't find the Name column correctly, because you define it as having quotes around it but it doesn't. ...
February 5, 2009 at 11:13 am
Reporting Services has a number of ways to publish data. Is that what you're looking for?
February 5, 2009 at 11:08 am
There's an option in SSIS file system tasks to not create the object (file or folder) if it already exists. Will that do what you need?
February 5, 2009 at 11:06 am
Jeff Moden (2/5/2009)
The ironic part about this whole discussion is that a code of ethics would only be followed by ethical people. 😉
True.
And even professions with published ethics rules...
February 5, 2009 at 11:03 am
The configuration manager you found in the start menu is just a limited client tool. Certainly installed because of an application.
The way to tell if you have SQL Server...
February 5, 2009 at 9:42 am
Have you run an integrity check on the database? That's where I'd start with what you're describing.
February 5, 2009 at 9:25 am
Christopher Stobbs (2/5/2009)
So it's more that the UNION is not that good rather than UNION ALL is not that good.So UNION ALL is ok basically if needed?
Either is okay...
February 5, 2009 at 9:24 am
Viewing 15 posts - 11,101 through 11,115 (of 14,953 total)