I installed the SP2 on the primary node, but it failed during the Notification and Client install. Did I miss a step?
I've installed the SP2 on three dev/test servers. I went to install on production and the install failed on the Nofication and Client updates. The...
Here's the solution - select convert(char(10),cast(DateIn as datetime),120)
We have a 3rd party application that connects to our SQL 2005 as a external database source. Our external database has a 'datein' field that for...
I'm running SQL 2000 sp3a and have replication going from serverA to serverB. We have had a few issue with power/network outages, which causes...
That was it... I tried applying SP1, but still didn't have the option of 'per object' (although I see another person did??) Once I applied SP2, there...
I don't have those options either... When I look at that screen, it has * Script to file Filename (box for destination script)...
In SQL 2000 there was an option to script each object to individual files. I can't find that option in SQL2005, it only give me the option to script...
I have a win 2003 server with a SQL2K Standard install. I need to extend the memory, in the article on Microsoft, it refers to the Enterprise Edition...
I have a few developers working on creating functions. What are the best practices on when and where to use them. Can you use it in the From, Where,...
We had a ping/post process, external webservices and internal clients all hitting the same database and server. It would take 8 seconds for one query...
Thanks for all your advice, although it maybe a little more complicated than I need for this project. I have a 'valeudetails' table, with a field...
I have a tables with a field of values and need to update it randomly between 1 or 5% negative or positive I believe I know the step, not sure where...
I thought there was a SQL Server stored procedure with a paramenter for the text you were looking for 'master'. It will then list all stored...
How long does a SP stay in the cache? Is it based on time or size?
I can't get this one to loop through the ziptrendindex table and replace the variable name. I was able to create a table using the exact syntax, but...
We have 4 clusters running 2005, each with the same install. I have been able to create Maintenance plans on all but on server. I get the error...
Tried to change the compattibility level, but no such luck. I'm DTSing as I type. Thanks SUsan
I believe there is no way to restore a 2005 backup on a 2000 server, but was hoping someone had some other suggestions. The datatbase is 11gigs......
I have a date field that is an int and I want to convert it,can I change an int into a datetime?
Separate names with a comma.
