Hi, I want to replicate data between two SQL Servers but I have connection problem: Server A: Win 2003 SP1, SQL Server 2000 Enterprise Edition SP3 Server B: Win XP SP2, SQL Server 2000 Personal Edition SP3 Server A dials to server B. Server A can ping server B (using IP) and I registered...more >>

Hello, I have SQL 2005 enterprise edition VLDB. During peak I am expecting nearly 20000 concurrent users accessing the databases. For storing the clients information I am planning to use a XML datatype. Since most of the data is mandatory I am planning to go for Typed XML (Schema pre defi...more >>

When I go to setup a backup job for my SQL Server 2005 I get the following error when I Choose Script Action to Job. Unable to to Script Action to SQL server agent Job. Addtional information Cannot show requested dialog (SqlMgmt) SQL agent i...more >>

Does anyone know an easy way to track if a view is being used? I am trying to see what objects, queries from linked servers, SQL jobs, interfaces, DTS jobs, and any other things might be touching a view. I've already consulted sysdepends, but it can only tell me about what's already in the ...more >>

Hello, I have a script that creates a new database table called MYDATABAE, then it will use USE [MYDATABASE] to create tables. Well.. It doesn't even get past the parser. It stops saying: Could not locate entry in sysdatabases for database 'MYDATABASE' Below you will see some of the sc...more >>

Hello I have a problem with a loading DB in Enterprise Manager. I had restored a DB from another Sql Server and something seems wrong. I´ve got no error message but I have a grey DB Icon with my DB Name and a loading behind the name. I can´t delete the DB with Enterprise manager, can´t open t...more >>

I am trying to understand the Wait_Time column in sys.dm_exec_requests. BOL says concerning Wait_Time: "If the request is currently blocked, this column returns the duration in milliseconds, of the current wait." In executing sys.dm_exec_requests, all my blocking_session_id's are zero, yet s...more >>

I'm using DMO in VB6 (because I haven't replaced VS 2003 with VS 2005 yet so I can't use SMO) to find out how much space is taken up by the indexes. My code looks like this: Dim total As Long total = 0 Dim database As SQLDMO.database Set database = server.Databases("mydata") Dim table...more >>

Hello, I am searching for an absolutely fastest SQL to locate overlapping time blocks. I've tried various things, but i am a c# guy, and sql is not my strongest suit. create table TimeBlocks ( TimeBlockStartsAt datetime TimeBlockEndsAt datetime ) I want to find a condition where one...more >>

I've currently come into an environment where the company is running SQL 2000 as the database for their primary business application. From a novice stand point the server seems to be improperly configured in a number of ways. The biggest red flag is the hardware setup, which consists of everyt...more >>

Hi all, Looks like I inherited a little collation problem, and it's causing me headaches. This is a little involved, so please bear with me: Most of the CHAR and VARCHAR columns in the tables of this database are set to SQL_Latin1_General_CP1_CI_AS collation. A few are set to SQL_Latin...more >>

I just installed the 180 day trial, but when I tried to create a new database I don't have the option to chnage the compatibility level to 90. My only two options are 70 and 80. Whatr did I do wrong? ANd how do I fix it? Do I have to uninstall and reinstall? thanks, Justin Miles ...more >>

This code snippet works fine in 2000 but not in 2005. Is this a bug? I get a conversion error on the 2005 server. Any ideas? Create table Sample (DESCR Char(30), Ref Char(50), Name Char(30)) Insert into sample values ('Valid Row','03/25/2006 02:30:15 PM','Joe') Insert into sample v...more >>

Is there any way to rerun all of the subscriptions at once after they have been run for the day. I had about 35 subscriptions that were set to run and 8 AM. We had a burp and they failed. I dont want to wai till tomorrow for them to try again. And would really rather not run them ind...more >>

I was just wondering what performance issue will be if you implement iSCSI based SAN Storage for a transactional as well as operational SQL Server 2000/2005 databases. Does the SAN be a dedicated storage per application database or can databases share a SAN and how much do you think disk I/O...more >>

SQL Server: 2005 OS: WIn2003 Mapped network drive: Z:\ with Full Control permission When I go to SQL 2005 and backup database, I cannot drive Z:\ Do I need to do anything in OS? Thanks Zrich ...more >>

Hello, I just installed SP4 with 2187 on one of our machine does anybody if i am covered with the AWE problem which was with the base(without any hotfixes) install of SP4 . I just wanted to make sure if i need to still install that fix or not after installing 2187. Thanks in advance, ...more >>

Hi everybody, I currently have a database with 700+ tables, most of them not in use (not containing any data at all). The database is going to be migrated for use with another application, but first I want to kick out all the empty tables (and maybe also all unused columns in the rest of the ...more >>

I have a SQL Server 2000 database that is approximately 30 GB in size. I set up the SQL Server maintenance plan with the SQL Server Enterprise Manager. I created the Optimization job and only selected the 'Reorganize data and index page' and 'Change free space per page percentage to 10%' ...more >>

Hi, I'm a developer who knows little about SQL Server (but I want to learn). I have an update script which has been running for about 5 hours. I checked the process using sp_who2 and it said the update is in 'Suspended' status. Is there anything that I can do to get the process running again ...more >>

I am looking for a way to dynamically create a database in SQL Server 2000 using a stored procedure that will create a dynamically named new database using the script from another database. More specifically, I would like to call a stored procedure that will pass in a new DB name and will take...more >>

I have a database plan that performs the following actions: 1) Backs up user databases 2) Backs up system databases 3) Cleans up .bak files older than 1 day 4) Cleans up .trn files older than 1 day The backups are being stored in subfolders and for the cleanup actions I have "Include First ...more >>

When putting together a Maintenance Plan, after selecting the databases, the topic is Data Optimization. Under this topic are options "Reorganize data and index pages" and "Remove unused space from database files". Can both or either of these be performed on a database that should be constantly ...more >>

Hi, Hope you can help me with this one. Advice greatly appreciated. We have a web application on a server (lets call it server "A"). Its talking to a DB server (lets call it server "B"). We want to backup server "B" so that in the event "B" fallsover - the backup server (lets call it "C") wi...more >>

Hi, Hope you can help me with this one. Advice greatly appreciated. We have a web application on a server (lets call it server "A"). Its talking to a DB server (lets call it server "B"). We want to backup server "B" so that in the event "B" fallsover - the backup server (lets call it "C") wi...more >>

Is there a system table that holds data on invalid objects/procedures? In Oracle, I can query dba_objects table where status='INVALID' to find all of the invalid objects. Is there anything similar in SQL Server? thanks! Susan...more >>

I know database mirroirng is on the database level but is it possible to fail all the databses in the server if one databses fails. If I want to mirror db1 and db2 serverA to db1 and db2 in serverb. If db1 in servera fails I want db2 in servera fails therefore both database will rollover to...more >>

Hi There, After we migrate our SQL 2000 databases, the compatibility level is set to "SQL Server 2000(80)" by default. My question are: 1. What are the differences in terms of performance runing databases under comp level 80 and comp level 90 in SQL 2005 ? 2. What do I lose if the databas...more >>

I am receiving this error intermittently: [380] Unable to start JobManager thread for job. (Thanks Sue Hoegenmeier for helping me to find the error!) The SQL Agent Jobs run fine as scheduled for several days then this error occurs out of the blue. I found 1 or 2 other strings that mention t...more >>

Hi, we have a local server with a database say A on it . we also have a linked server which has a database B. now we are trying to insert into a table in a using data from the database B. both of the tables in both the database are the same in structure . now when i use a query like insert in...more >>

It allways show the same list as in the Object Explorer, doesn't it? For instance, you click on a table in Object Explorer, and all you see in the Summary pane is 95% white space and "Columns, Keys, Constraints, ..." in the top left corner. What use is that ?? Am I missing something ? (S...more >>

Hi! I have the week number and the year. I want get all the dates that fall in that week. Is anyone who has idea to get this? Baren...more >>

We have a Windows Server 2003 SP1, SQL Server 2005 SP1. When the machine is rebooted, the SQL Server agent is not automatically started. It is set to start automatically in the Windows Services dialog. I see a safe shutdown prior to the reboot, but no messages like it's even trying to start u...more >>

Hi, I whised to run a T-SQL script as a SQL server Job that uses a linked server to connect to a remote DB. When I run the stored procedure in Query Analyser (with a specified user) everything works fone but on SQL Agent I have the following error: Access to the remote server is denied bec...more >>

Hi all, I created a job in SQL Agent with 1 step which includes 2 step, e.g. sp_start_job 'step1' and sp_start_job 'step2'. step1 and step2 are 2 agent jobs. How can I continue the step2 while the 1st sp_start_job 'step1' is failed? Thanks in advance ...more >>

Hi everyone, I have a question about the replication technology on SQL Server 2000. Lets say that we have 2 servers (names A & B foir convenicce). Server "A" is the primary and "B" the backup server. There exists a transactional replication process - a Central Publisher/Distributor Mode...more >>

One thing that seems goofy to me is why an owner of a database has to have explicit permissions set. I guess I don't understand the mindset of the whole security getup in 2005. If I'm the owner of a car, yeah, well, I pretty much have unlimited permissions on that car. Why is this different in...more >>

Hi All, I have some problem where i want to running my job. I have 3 Package(A, B, and C). And then i created again Package D. In DTS D i run my 3 Package(A, B and C). The workflow is If A success then run B, If B success then Run C. After i created DTS D. I make a job for DTS D. I run this ...more >>

Is there a way to get the total # of queries (not just transactions) executed against a database for a given time period. I figure I could track it using profiler, but I don't want to analyze the queries in any way, I just want an idea of the load on the server. One reason would be so I could ...more >>

Hi, In my SQL Server 2000, MyTable, I have data like this: 1A A a 123 2A A aa 456 2A A aa 789 2A A aa 888 4B B b 147 5B B bb 258 What will be the SQL syntax for the query so that the output is 1A 1 a 123 2A 1 aa ...more >>