Viewing 15 posts - 691 through 705 (of 1,478 total)
Jeff Moden (1/20/2010)
You can also use a pass through view with the columns in the correct order.
This will work on most cases, but in case that the file has more...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 21, 2010 at 10:11 am
Its been a while since I’ve worked with log shipping, but as far as I remember, it simply does the reindex operation on the secondary database just like it was...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 20, 2010 at 8:50 am
If I understood your question correctly, you can use a format file in order to insert data from a file that has different number of values then the table’s columns...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 20, 2010 at 6:12 am
Are you using a backup file that contains few backups of the database? If you are doing a backup and pointing it a file that already exists and has...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 19, 2010 at 4:38 am
Check the creation date of those procedures in the source database and compare it with the Backup's date.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 19, 2010 at 3:36 am
You can create a table with the needed date and then use a cross join with your original table in order to get all the combinations between each date and...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 19, 2010 at 2:16 am
Notice that both queries are not the same. The second query that uses the between operator will also return records where column SAMPLE_DATE has the date 2003-04-10 in it...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 19, 2010 at 2:02 am
arun.sas (1/18/2010)
What you have written in the statement is correct, but you should convert the date time type by convert (varchar (15), tet.dteTravelDate, 103)
(case when pt.intPointTypeID = 1 then convert...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 19, 2010 at 1:34 am
Matt Miller (#4) (1/15/2010)
Seth Lynch (1/15/2010)
Spot on 😛Thank-you
Seth
.
Keep in mind that may execute under the service account context, which could show you the location of the IIS server serving up...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 18, 2010 at 2:28 am
Only way that I know is to check old SQL Server’s error logs and\or event viewer logs from that time frame.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 18, 2010 at 1:34 am
There are some tables that you can’t truncate. One of the conditions is that the table is not referenced in a foreign key constraint. Unfortunately even if...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 18, 2010 at 1:29 am
As far as I know, create procedure permissions can be granted (and denied) only on a database level and not on schema level. You could grant it to the...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 18, 2010 at 1:24 am
Jeff Moden (1/17/2010)
Ummmm... I tried to find xp_restore_filelistonly in my installation of 2k5 and it doesn't exist nor is it in Books Online.
If I remember correctly this is an extended...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 18, 2010 at 1:08 am
I don’t have here a SQL Server 2000, so I can’t try a solution. One way of doing so is to add a new level to the query. ...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 17, 2010 at 4:56 am
It means that one of the queries inside the isnull function returns more then 1 value, which is not allows. Here is a small demonstrations of the subject:
--returns an...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 17, 2010 at 2:12 am
Viewing 15 posts - 691 through 705 (of 1,478 total)