So are you trying to rename the file in a folder, or change the source filename for a connection?To change the filename in a folder, there isn't a file rename method so just use the MoveFile method to do the rename.For for the source filename, you'll need to create an object that refers to the connection […]
2005-05-03
2005-04-05
I do not know of any limitations but apparently the problem does exist ... Here's a link I googled ... http://archives.devshed.com/a/ng/373-78/Password-Length-Issue-With-SQL-Server-2000
2005-03-02
EDIT: Upon a second read, this is identical to the ISNULL version pposted earlier - sorry for the redundancy. One last version: select case when NULLIF(RTRIM(Record1),'') IS NULL THEN 0 ELSE 1 END +case when NULLIF(RTRIM(Record2),'') IS NULL THEN 0 ELSE 1 END +case when NULLIF(RTRIM(Record3),'') IS NULL THEN 0 ELSE 1 END AS MyCount […]
2005-02-23
Hi,I want to attach the database thru Enterprise Manager, but i have only .mdf file. i dont have the .ldf file. so how to attach the database with out ldf file. if possible u can give thru sql query also.when i am attaching the database, i'm getting the following error."Error 1813: Could not open new […]
2005-02-23
87 reads
Have You tried to get an RDP connection to the server instead, and using the necessesary tools remote?Regads Ib
2005-02-23
Before looking for SQL Server 7.0, see if this helps:http://support.microsoft.com/default.aspx?scid=kb;EN-US;261334http://support.microsoft.com/default.aspx?scid=kb;en-us;818550
2005-02-14
After having been in the Oracle world for the past four years, I'm just getting started with SqlServer and have a general question for the SqlServer DBA crowd: What toolkits, home written or vendor supplied, do you use as a general purpose monitoring suite? The types of things that I'm talking span a variety of […]
2005-02-11
1 reads
Does anyone know of a way to use the user's NT login that authenticates with SRS as a parameter in a SRS report. I need to pass the user's login (domain\jdoe) to the report to cross reference that with a table that will provide a parameter for the department value in a report.
2005-01-24
I have done it before. You have to write your entire statement to a variable and then use sp_executeSQL to process it.With that said IF I knew then what I know now I would not do it. I would instead have used Table UDFs that have parameters passed into them and avoid the whole dynamic […]
2004-12-23
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers